Evaluate Rows Number In a Table (Wait for SQL)
Description
Evaluate Rows Number in a Table (Wait for SQL) scans a database table and checks whether the row count meets user-defined conditions. Use this process entry when your process needs to poll a database until data arrives — for example, waiting for a batch load to complete before triggering a downstream workflow, or periodically checking a queue table until new records appear. It supports custom SQL statements and configurable polling intervals for flexible condition checking.
Configurations
| Field Name | Description |
|---|---|
| Process Entry name | Specify a unique name for the process entry, on the workspace area. A process entry can be placed on the canvas several times; and each instance of the entry must have a unique name. |
| Connection | Identifies the database connection to use |
| Target schema | Name of the table schema to evaluate |
| Target table name | Name of the table to evaluate |
| Success when rows count | Defines the evaluation method used to compare the number of rows with the given value |
| Value | Defines the value used for the evaluation |
| Maximum timeout | After this timeout period, the process entry continues with a fail, by default, or success, if the Success on timeout option is checked |
| Check cycle time | Sets the amount time between evaluations |
| Success on timeout | Defines process entry success behavior when timeout is reached---when checked, reaching the maximum timeout limit causes the process entry to succeed. When left unchecked, reaching the maximum timeout limit causes the process entry to fail. |
| Custom SQL | Enables the use of custom SQL queries |
| Use variable substitution | Replaces environment variables in the SQL script with their actual value |
| Clear list of result rows before execution | Clears the list of result rows before running this process entry |
| Add rows to result | Includes returned rows to the result set |